package com.sc.nft.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sc.nft.entity.SandWithdrawRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sc.nft.entity.vo.MoneyRiskPageVO;
import com.sc.nft.entity.vo.WithdrawRecordVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 用户提现表(sc_sand_withdraw_record)数据Mapper
 *
 * @author zxy
 * @since 2023-01-01 20:36:37
 * @description 由 Mybatisplus Code Generator 创建
*/
@Mapper
public interface SandWithdrawRecordMapper extends BaseMapper<SandWithdrawRecord> {

    /**
     * 昨日累积提现到银行卡总金额
     * @return
     */
    BigDecimal getToDayWithdrawAmount();

    BigDecimal getToDayWithdrawAmountByDay(@Param("day") String day);

    Page<MoneyRiskPageVO> moneyRiskAdminPage(Page page, @Param("userId")Long userId, @Param("name")String name);

    Page<WithdrawRecordVO> getWithdrawRecord(Page toMp,@Param("channel")Integer channel, @Param("startTime") Date startTime,@Param("endTime") Date endTime,@Param("orderNo") String orderNo,
                                             @Param("status") Integer status,@Param("confirmStatus") Boolean confirmStatus,@Param("userTel") String userTel);
}
